SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596980 LIMIT 1 [ RunTime:0.001019s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596980 [ RunTime:0.002334s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465684,967324,180172,7497,565103,57355,183014,440964,639041,427224,712403,136333,963010,199699,885880,518061,1008318,964426,424060,348345,59847,883032,54502,468631,295799,351200,807093,472555,841064,865021,754941,785212,242239,46689,732823,35094,890684,115535,347748,999012,230140,543428,427847,410284,650834,869089,423337,244345,392212,980613,511903,440102,1042116,1037413,785535,403967,76560,49782,35933,926106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.033799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003209s ]