SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412610 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412610 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024901,945965,854898,805275,773297,185749,655452,309774,780622,1046856,454118,897453,991036,468104,383790,779155,896003,755719,474647,969826,117739,248193,858775,194526,687093,778243,103904,803968,559043,458487,57574,1046843,964936,257930,861584,636374,699479,985271,248904,976548,522615,367082,839639,1039051,813326,202622,467108,718121,194844,676329,643531,691773,431,60690,347349,4077,813926,124018,702277,261077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]