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` = 484417 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484417 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673121,912943,625606,59311,969730,61239,342018,993842,10842,360748,914208,253144,807634,376908,400376,965133,556653,648620,136530,712486,355905,76208,696120,158091,415937,698339,147896,720529,138111,874655,62809,626179,129601,459343,247651,852115,137010,153949,695681,623985,570451,1033021,980404,395381,8750,258763,436682,214566,192547,863392,478950,932265,856826,939671,827837,330157,28855,565590,372995,938658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]