SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001924s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598532 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598532 [ RunTime:0.002843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440186,813229,243852,949810,320153,572072,1028425,1039953,574912,258678,479241,363972,627256,50259,534355,88798,405495,832214,312011,408261,660412,482489,787450,523087,499267,1026898,49928,185201,240159,607187,770297,445739,100878,24829,503404,803244,565524,244339,708283,216331,574810,1010917,785077,618498,587800,488346,565125,205491,49617,523300,693081,344690,437211,598662,30976,56966,467555,822369,650270,407628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598532 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598532 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]