SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438012 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438012 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782015,397021,798676,525445,400250,931690,169665,817674,629476,552331,83412,611990,162771,920833,921338,925965,727077,400913,1034303,724513,826665,688117,591192,561056,953177,97421,655161,41890,863753,505633,488401,595913,596399,567882,316785,1026630,606879,363081,926950,850587,924913,385557,138941,617445,307177,267359,999820,681213,345992,265932,457974,82377,371082,774826,557220,702169,44350,72010,108324,790228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]