SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54508 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54508 [ RunTime:0.003098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232047,938484,114818,659651,474416,341199,361996,167687,856857,22254,196985,487656,235410,414056,806562,261405,37614,294610,209715,110631,961564,537333,733804,10991,244473,132029,408039,787286,691588,581161,410199,456245,876743,152864,1035474,1014033,356634,903775,539162,729549,489612,107281,157367,387881,369012,293798,309349,714606,108233,1043812,1047631,273840,593554,1037339,219355,719861,264192,785717,682368,354212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]