SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984068 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984068 [ RunTime:0.002840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008248,280515,670480,71104,701991,872952,371114,190636,430751,494158,532517,148501,535455,809443,939011,992890,192380,836596,777014,677376,440958,36236,825903,415223,582052,542987,1033663,812134,826457,403710,543293,387478,55043,615613,233472,1032045,796359,125070,322622,140859,553215,656983,328366,791704,276549,745841,477829,287735,539644,1041769,232014,111776,61917,999797,468431,773875,791452,187480,431914,10053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]