SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010504 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010504 [ RunTime:0.002384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834424,830870,222327,412948,296450,904639,333094,895083,413010,624267,554325,93203,849882,650447,10752,48259,56161,537889,504595,435309,763592,647543,919656,837498,331881,1040051,118147,177264,260285,264433,664111,501749,263587,23294,1028893,320806,376276,5866,619103,905752,87822,457325,257042,832610,312408,441729,425651,154561,343157,347291,326725,609268,24112,1043272,404254,377371,368614,92734,487490,527462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]