SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334728 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334728 [ RunTime:0.003386s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41547,793040,762691,814603,1030647,69630,33770,592355,460189,226019,981462,18854,246456,793665,760599,983433,844272,115044,572774,1027796,124779,502515,681543,358310,578874,355228,663769,131190,412106,926362,588614,194204,467913,126636,720310,552060,476776,403511,858879,75677,4080,261444,707923,253582,903728,630513,339633,184210,801940,504815,333734,510134,420437,987483,454975,941803,660649,39287,457129,1043926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]