SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407891 LIMIT 1 [ RunTime:0.004280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407891 [ RunTime:0.001451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905327,36887,883747,811295,706030,677873,569213,875893,718524,667978,151922,718537,930348,809397,650180,311721,425207,887648,601418,222362,809151,122355,87274,418178,616753,742036,1016167,242713,232476,56541,459592,576191,551324,878651,286572,994484,516958,692109,159029,120812,377200,233799,298222,923711,142199,730360,997851,90876,831769,1004744,345003,263381,686931,194214,253198,1037788,164003,505343,578341,570904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001727s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000812s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]