SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507003 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507003 [ RunTime:0.002699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730945,108098,4153,990070,552713,590610,90577,654727,309802,625951,286331,384677,601558,131774,552024,231765,201347,602111,44472,226795,116385,906282,176752,809473,413184,596291,830581,186700,185649,196357,1016128,1025622,754480,612032,358217,516037,416682,773454,860471,129875,803418,425958,190376,675244,1019871,142861,793388,524688,122130,544076,724828,745151,892190,454208,923646,221588,25347,306859,980795,938452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]