SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476223 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476223 [ RunTime:0.002537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132499,638891,318241,684601,446976,803024,740237,156048,191486,63807,404235,123459,254197,532197,207073,323363,214570,41341,499392,810472,806205,873148,1025939,388196,1043215,269130,128608,89764,391974,505729,877056,171187,858005,291315,278951,451838,475867,127423,719396,670056,811136,386646,422196,699028,269327,1041321,776030,91234,55802,110809,809486,565233,653552,933156,868779,49172,547309,1009183,400204,581220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002216s ]