SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10440 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10440 [ RunTime:0.003247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474734,787558,597126,19184,311272,722931,217692,737859,1035181,710092,201301,1040504,750887,382879,628708,393364,70861,684430,674355,1004149,577441,20692,149344,531624,16633,221318,1027496,78414,756807,369040,829504,624350,549043,824052,549669,798374,811988,733672,940521,1012549,597068,969830,250718,475159,221710,526441,431410,897967,462980,306659,641538,484452,926605,439982,755292,75487,752783,278819,904224,89447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]