SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41325 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41325 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538744,8191,444804,801605,228594,433342,874464,272939,495959,585051,733154,1013181,300021,67992,100899,2422,627609,192824,15183,1038536,953221,688760,275119,497185,984062,780528,24974,16908,76715,1022788,311598,389427,960953,1037517,590991,787314,671826,179328,833548,476972,451883,626905,189143,50254,579412,630604,311999,820195,131769,256337,331544,121842,303523,774012,593218,160047,238104,761691,1020512,884949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41325 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41325 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]