SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 609412 LIMIT 1 [ RunTime:0.000551s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 609412 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33518,1043959,769678,82297,991027,237456,1009325,303753,666139,800518,205949,102875,450999,108695,636897,524657,1011507,327695,477225,656702,1003603,52430,308905,456491,421745,902554,894119,54596,155269,664009,162687,991009,72044,7688,294159,242278,372057,321228,199597,267934,445668,313469,743404,441591,277731,635323,911077,525516,330117,307834,858896,761436,521318,632968,116451,146908,501351,493850,925407,136726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 609412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 609412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]