SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027068 LIMIT 1 [ RunTime:0.000736s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027068 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471518,564448,909909,326402,984582,340741,771055,876445,938956,647538,555814,424506,20332,947144,746911,696388,182706,175024,754377,50330,768492,626765,231346,213564,141572,56939,941350,579391,623752,594910,136841,967697,198682,785773,562179,779739,71085,447295,744939,18823,403841,127879,611320,167371,17819,997858,499150,499541,643865,78860,600059,416791,909847,75163,840408,71895,942804,397039,943060,159772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001255s ]