SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470958 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470958 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679809,834112,777802,428174,85087,234232,834678,370515,1013968,41034,827613,340163,805482,511030,620296,237227,27761,592741,222717,668210,569417,274879,82337,270545,826450,603334,845669,112610,742404,854377,353300,839821,281811,750763,138945,430811,527444,484988,152291,106877,830112,751418,341347,22594,105112,966864,645991,1000687,851214,65513,61238,290067,1013237,75081,157360,788651,595787,512842,516641,256510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]