SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026157 LIMIT 1 [ RunTime:0.001748s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026157 [ RunTime:0.006628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (578700,536938,384599,938001,315868,454674,697208,271108,1025969,673103,196491,401203,103299,583519,894611,990640,637012,775977,88045,221329,321675,939663,973175,986004,152462,679614,761116,515668,952916,994841,715811,228961,130578,457243,1020514,627961,496169,166517,424120,157456,67485,555931,585856,147840,592636,535348,757578,1046771,772061,150837,892056,670339,277987,1009290,605333,755436,677089,512804,649716,521101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002292s ]