SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201445 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201445 [ RunTime:0.002402s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419470,245149,798949,755513,98521,448143,1037121,378234,359498,272877,509562,694716,1047537,557096,524031,627076,875026,403036,609178,522575,472640,691225,115755,843830,355987,335063,306394,550258,728611,497933,281435,776302,108150,148097,161363,338434,771974,655944,728184,597574,279340,747345,227435,118470,203802,279289,686646,711297,804783,379436,935980,604180,876221,937603,224474,1016859,441106,766898,831420,689672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]