SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455412 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455412 [ RunTime:0.003058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909194,426692,980277,110560,858963,346957,108793,445784,111140,498163,1002882,186670,391355,289067,427410,290686,175434,678546,894323,588542,628256,689857,179976,294169,386678,888790,617321,587002,734666,665713,943386,327666,685893,118965,631033,226725,269046,619634,262432,126321,217141,773065,578195,362198,57450,10457,205464,209051,594459,115353,14274,688274,90683,300844,606095,449784,1006974,393266,352012,689383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]