SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044226 LIMIT 1 [ RunTime:0.001076s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044226 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428810,656114,463707,974308,967183,28598,84578,617013,824957,156888,384977,1046806,154961,786077,401757,640019,848516,164676,738994,86556,241139,9676,243802,6255,870802,237077,855411,211109,78862,266777,573343,816927,54185,255903,646059,673136,634856,243965,978950,306303,537628,1013611,463721,438228,726991,869496,467965,493568,693915,317456,604732,482261,498956,435099,687397,971841,632552,350347,90001,311267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]