SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048770 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048770 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298808,753887,617048,969546,311225,847779,299141,933218,799366,483433,173341,60223,297026,432483,605800,384491,189600,809581,365883,1023719,276958,893154,84913,493744,858799,677894,44246,1027055,923876,660572,418076,518445,101308,555664,337569,348606,119477,1002595,564604,102253,648679,429310,272981,723116,1017710,410829,148087,784807,146041,653096,538321,161711,477864,662198,933688,371923,530560,765729,628810,785369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]