SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469015 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469015 [ RunTime:0.002949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742475,620798,374595,828245,837490,1000306,119470,773170,713997,50109,323486,87999,588243,580076,581575,1036912,201277,639331,545124,636014,547912,67916,494276,524978,872638,762844,10864,551853,276163,784222,21561,423704,868515,299734,765374,271881,694007,447701,15349,471398,599066,527022,954997,950365,358442,659021,998453,575172,299421,276922,307445,531579,376828,416858,721074,634932,837580,463798,352514,123828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002904s ]