SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283176 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283176 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261678,948577,428487,830632,511340,560014,481861,1047852,608552,563797,138343,145649,963874,994428,200507,692464,503500,177533,854932,872458,1038236,603455,833138,920321,195692,285578,391484,836026,19369,689610,75540,1002084,337494,733398,46618,87623,1016440,652509,794194,57431,99145,982777,832490,12121,437686,450638,895208,1019811,557601,882922,487539,312637,966551,307522,599863,82940,497624,329569,195858,457112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]