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` = 289210 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289210 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799330,817572,415718,1022934,612850,168287,1018056,210391,247473,409830,106331,631073,798744,533337,687949,589694,984388,34294,327637,759506,538589,301197,139057,248349,243573,102274,518703,913679,107883,385951,354040,792087,1024410,21233,651476,842283,835738,717474,25037,11691,34203,291356,980315,728942,950392,193425,254386,926277,149093,406936,498009,286877,352319,1022025,741602,570093,790201,941938,143339,473271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]