SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426202 LIMIT 1 [ RunTime:0.000833s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426202 [ RunTime:0.003077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318060,194055,794621,893398,314621,970472,848290,844664,285691,333622,35277,655530,223388,1044993,687403,1035880,50618,640275,492314,815636,598829,98560,756861,44525,213530,597,935671,257435,935128,653903,645076,132635,958305,619712,764720,15531,113641,281113,138389,642272,501822,740943,460742,34286,908331,455041,206214,134114,1023769,847547,885493,637564,544433,35276,695760,234416,835227,110803,1000007,796614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001203s ]