SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487833 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487833 [ RunTime:0.002716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120810,346431,34107,327626,259193,159310,39188,908110,781440,18518,23724,699557,817955,134471,281299,1035471,773551,101050,464917,91970,268904,175519,887375,948370,315734,836938,341259,271437,605932,163454,636449,801668,421975,185606,68848,86373,343575,430541,673840,42189,591672,311540,23041,238996,462130,776597,911063,666818,48394,191117,239408,275076,893270,919414,833566,155205,818661,50288,511923,303989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]