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` = 342603 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342603 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984218,958601,704944,473876,1029802,796927,871167,442404,594566,382045,795600,85401,556450,792178,249006,748671,682343,174982,80192,527541,790196,638841,359649,187993,231775,159654,571196,250485,609996,429266,776111,590522,1022259,388982,1038599,841966,8215,1036681,938769,691291,934673,164190,599941,610045,121065,116715,413400,757788,835958,138103,366135,237582,717223,402489,88406,688546,856873,849367,115776,610022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001759s ]