SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59438 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59438 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917215,463367,666244,471978,659534,760013,547158,302621,351126,805877,49280,766059,968391,217679,14471,579151,96014,835905,888396,998370,355435,716748,392275,334472,603803,890824,367949,583559,531106,699271,661335,321909,145257,21966,986938,451006,372721,1010042,848800,797391,142185,13363,817383,938791,71278,247051,182805,506949,768008,909086,354127,450439,921351,150964,516260,95747,529365,682788,617654,936789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002362s ]