SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020539 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020539 [ RunTime:0.002686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565837,77265,291542,550009,235837,313340,412753,127760,957188,604899,300243,795748,957819,915449,549107,413169,675688,801226,135394,869851,109947,940127,554012,789929,925065,85553,238972,325918,705051,593698,497956,1025923,81008,691416,738723,704798,168254,828646,612991,883598,946456,146088,773706,209508,1021269,595980,999773,876115,986243,340546,408414,35828,639084,325259,1018971,655352,362858,308542,696390,940632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]