SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040428 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040428 [ RunTime:0.001430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418788,255386,954416,265260,902756,63809,562825,717609,405614,138047,610515,551104,1015137,208730,401334,768764,570159,643538,901306,256841,920638,849198,610331,91041,1016804,927491,80839,47421,950578,740153,134183,676106,583097,925652,350051,1012844,527692,447363,733052,362570,951577,227735,609630,411391,227837,845472,51892,496835,658707,515497,653805,306865,398404,843603,484954,55256,878805,106888,20337,417324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]