SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311052 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311052 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312056,322847,369605,380735,181554,72637,482727,398451,94750,772576,583919,584736,660053,659022,246793,461937,301844,101461,314693,1015012,16728,4633,29748,372362,71548,384688,610630,80479,256183,832035,313359,631611,415693,736258,791332,976421,444850,1033099,869508,915273,565248,980012,19164,74134,840664,811488,767113,1006917,855573,866243,839700,841920,330851,422179,666175,98570,185091,1045568,391714,154167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000383s ]