SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 647904 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 647904 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545081,626262,91526,163514,585950,1016365,518773,589313,528523,853383,253086,513980,278910,178752,259670,981883,27993,42769,1044121,830468,953073,1010427,578843,654431,495210,8948,569148,629342,300146,421417,193384,709619,370158,38735,411574,661004,599468,148078,25293,44934,66017,49552,507735,103234,139638,69792,381119,500682,292525,947233,961022,278371,155128,127553,243644,465240,347841,916966,320695,242054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 647904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 647904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]