SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013170 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013170 [ RunTime:0.003044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166228,781737,573342,760603,233962,199692,853776,670837,70265,510034,782102,30430,170698,682873,938011,214013,91458,169317,640729,1014490,691745,329739,465887,661000,179333,229833,572997,220676,280336,283448,734035,937883,45378,919075,410325,35814,341132,122006,875927,122272,535284,172642,393172,668003,122652,896017,833252,308767,394258,816148,779697,12000,575478,760872,685579,543298,861043,537167,761991,219666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]