SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564193 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564193 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243822,269050,761435,236961,1016469,795556,1002967,287086,327378,227886,1024107,545522,912061,213938,450861,485086,241411,429546,429611,826444,372124,635912,381319,445667,305437,153218,96070,593620,545132,331055,437747,325057,546772,1008931,573662,647399,38652,627960,710840,575595,454526,883593,1001688,691034,244612,947544,69285,327125,93201,724324,661095,758845,193688,41294,261227,166900,742194,330319,51411,322235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]