SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004884s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425111 LIMIT 1 [ RunTime:0.000676s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425111 [ RunTime:0.004222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410124,512455,389872,659566,828088,543687,113349,25917,582512,847623,864012,498251,147121,604727,405120,222191,205994,304477,425147,543732,933686,578411,936022,690154,453793,290048,70958,777529,520738,669842,67290,439978,315587,176982,640170,419128,696650,143999,872319,917687,939914,843627,1032496,474826,944311,21298,989614,354954,804062,286712,213570,795464,653363,174783,168519,206359,116554,532762,652451,713734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]