SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368308 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368308 [ RunTime:0.003834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975644,626543,313708,904375,780514,544166,80733,480964,814728,995706,110349,693917,922077,152199,313858,621874,146305,507254,288472,272028,571806,348795,5531,436406,268568,256703,976319,47718,638578,396347,698667,357190,884291,357238,606756,979351,655621,176824,390939,542129,180148,209012,578752,730936,954512,777960,597639,901371,398690,1037367,3278,779610,436293,150409,166736,538238,917101,713769,490586,776195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001162s ]