SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001575s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022072 LIMIT 1 [ RunTime:0.001890s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022072 [ RunTime:0.002417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500353,988658,497571,351639,377506,689972,642793,144013,740103,488185,711379,286947,588401,52705,648955,222047,234513,1031871,57556,572351,693466,282132,815105,178786,1003477,648651,782938,340351,389250,1023770,903164,384757,633134,669419,702896,634240,798536,832980,666221,844318,724587,842543,670751,374517,177834,407419,182086,138375,81890,1026920,404773,636579,532961,70742,751636,265773,604789,640749,718015,593895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]