SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44552 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44552 [ RunTime:0.002441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330012,50671,505171,428231,341702,300831,594911,366186,256574,385945,271203,223234,346628,459104,700789,354430,246428,901917,140212,245268,761458,61157,425056,636170,936383,633323,474152,932657,300880,806001,1005626,122463,759231,823216,656898,405574,354038,210229,598621,439707,674464,948435,663490,97357,986772,23355,554131,575347,1048603,1040579,691681,694907,436330,761595,780983,826384,872909,77907,129174,215349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]