SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409980 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409980 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615512,795201,469299,635978,282566,900044,347993,93180,219609,976653,659071,694309,167315,102692,328065,109739,404030,817294,321271,79997,83751,805133,771720,787127,841022,690856,485519,233164,207184,64129,583678,5764,224611,865717,997245,644087,486588,442891,501927,177816,594270,615018,151058,740388,872610,798710,328594,436300,577982,922053,210935,395645,775224,665458,470821,10283,264410,272572,380748,12602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]