SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036730 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036730 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355404,217644,758227,459860,1026040,632690,996698,242304,225800,854555,77490,54469,946048,754543,290593,68938,801896,657383,739001,900596,398052,936849,812019,339638,153446,82360,363595,236752,475615,74327,720803,1041200,331107,451648,397711,938836,1038221,584426,525975,425488,228750,23046,499713,67021,954735,735682,463880,664116,596714,325913,209124,51162,253779,127668,968947,248584,263246,55013,787322,542006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]