SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001690s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293007 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293007 [ RunTime:0.002244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002389,459548,500245,342189,312199,199835,852518,511155,143064,803912,212692,91116,14951,477855,649352,489166,1017599,299147,381559,826982,382578,730207,414076,991966,293083,620288,628522,223927,592796,427419,479406,784225,69997,211869,731130,44049,705736,184545,883339,789136,959730,331156,923191,77475,224341,503378,467011,265419,155420,132644,225135,262607,643316,223400,979106,741128,787672,746736,492738,365583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]