SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438144 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438144 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282889,521896,58792,432538,562784,755850,849414,748455,458807,334091,3662,506972,12030,757873,216176,984045,62161,735670,716426,632903,143099,702608,405319,1018184,209729,201583,377503,576703,123908,486993,191296,476192,847803,745433,23116,484215,832844,187721,294405,686223,74742,675120,534911,840947,445550,865282,389823,493175,969292,1024285,110554,249439,223472,378202,223343,723108,794629,117394,637334,916370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]