SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587612 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587612 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541527,340970,142179,119763,970079,51663,624806,142142,662919,248286,165890,910403,803740,999735,703042,221419,594292,618422,338648,327121,35049,325088,1008605,78801,758471,701500,537484,846766,382990,407604,823123,248522,478558,695710,201617,723595,1036782,716099,229693,1032496,515667,345761,633090,1008103,537184,90059,1021950,686131,51913,741308,845921,212039,393384,441603,765284,827853,949950,704610,234600,808845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]