SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 651527 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 651527 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113500,680483,200950,572873,669400,817184,161556,281670,1004182,808610,247455,1036045,116634,534660,472332,248141,341282,320393,418627,68489,96302,742820,767204,786818,170936,256300,368076,433236,828515,423563,383377,232812,332514,68552,25969,489389,878396,668385,450870,480172,531343,151570,43138,435312,364903,191591,690932,33311,811518,273731,748600,81040,437632,1037111,1021856,907571,619625,409345,48192,327807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 651527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 651527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000752s ]