SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436933 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436933 [ RunTime:0.003143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752338,163233,898516,345203,891595,156110,206619,639395,876418,709644,637386,913493,1024695,38657,55375,455535,200079,293954,1014376,758661,773927,640457,111514,657809,632410,924835,708705,531605,188209,191837,675886,413999,558141,803197,528892,681884,1030959,649228,308313,921323,335979,346585,365433,207979,1025929,639332,518804,873461,121697,291098,417101,883888,890178,264784,776249,444794,478112,967273,178119,279560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001587s ]