SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028150 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028150 [ RunTime:0.002849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376714,54179,180709,456800,888281,713833,131082,585208,712138,44363,729970,75182,314996,791825,275575,999035,549861,420245,694777,521086,711447,686209,313391,58566,337527,671131,889598,706731,417638,117180,137654,687446,202367,969017,887603,936312,441830,97489,192604,61951,717139,231468,952798,903999,452349,797245,825476,517797,445601,315223,104435,877243,157410,868242,803845,973327,134467,805579,229362,113108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]