SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297983 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297983 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505253,537078,471939,91706,173615,657966,442725,558882,587127,120012,881451,969009,269613,150335,430580,127449,894183,228542,497016,395723,335510,820897,913927,877814,968600,484532,34338,105916,501231,941870,499318,448042,176302,988844,861445,34804,800587,797885,446881,446970,666435,379064,127998,1016553,888301,791213,51148,243061,232936,783042,55918,1018063,168683,405560,366579,942998,177208,231729,576087,140226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]