SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003038s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043807 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043807 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967145,864360,159807,1013792,753218,688396,726776,301163,925765,793118,14618,128748,102235,458444,1032951,81133,919735,515525,198206,555173,387822,918207,487546,616902,743504,80631,1014479,602310,140143,1039698,48492,159962,394432,954978,754019,644442,10505,454631,122211,33881,7387,344423,537028,843584,648406,1021235,500222,511653,306248,409881,343939,133787,193184,580904,265171,17394,771250,1026592,870984,886112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]