SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001867s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431181 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431181 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893232,578452,1000105,188862,444875,805990,267584,719765,608867,92775,194007,995583,71630,213703,770753,626531,291884,172563,78242,506337,869370,316602,1048075,680611,287341,494210,185748,696485,622453,79167,443952,369662,157409,211282,37489,481740,967760,756949,1045171,214573,711221,168596,901285,33510,515740,808263,410742,54301,236771,431783,635062,258489,36194,563320,471952,680540,911706,834066,736231,30198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]