SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027896 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027896 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (877563,135287,211249,889289,93154,541935,540879,171034,798209,305126,456959,544760,950595,379597,38291,348587,444097,443339,186014,466927,63816,876880,194029,696104,564226,453221,536218,588523,282030,391724,25145,748396,273672,932480,241723,411511,40059,361491,522104,390669,45321,646923,619573,356585,673376,891145,708031,1036922,979623,992208,864132,390156,699721,6903,341400,783437,189919,988554,159287,686083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]