SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501023 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501023 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (737831,449616,52759,570921,1015381,772755,1041042,49211,145625,483074,944548,342161,830530,682663,356731,319851,882222,876764,978255,976818,469435,626582,533073,866544,375869,122549,122221,879745,802792,46166,717047,505773,698132,805909,414927,501773,192009,143645,814830,958081,840314,949045,628555,738245,705898,154892,110366,1033327,531918,101710,653587,1008332,425266,611891,859610,810814,59313,905997,637355,391956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]