SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438200 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438200 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65010,704076,61168,726221,1006270,634012,95117,373011,832621,687498,166001,435823,990003,993193,712229,659922,171958,415655,831223,619834,1028484,761015,371779,792610,312826,519255,956761,377036,649714,940364,917140,703744,784641,550710,552467,548674,558336,294804,72714,546700,295517,131415,269770,957638,661033,719394,136889,542565,62518,63591,875820,559011,556366,528953,498353,397631,327925,911445,677264,818065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]