SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101584 LIMIT 1 [ RunTime:0.001575s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101584 [ RunTime:0.002234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663609,961458,59641,780490,334547,384038,75588,817660,1019369,436217,608667,909208,899544,756381,990079,473623,590283,11836,906043,842800,679495,229062,213334,937913,949910,935402,440561,333834,576845,511471,779330,273376,737671,406741,338273,432362,4630,1001612,933020,420874,514769,812132,88559,524225,229160,994487,870800,593800,693334,372348,241163,621294,684233,33680,728224,539574,431201,517137,967560,809119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]