SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34435 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34435 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401060,739709,89566,59195,42955,213242,536303,693512,122499,721924,115248,291222,837832,623186,189214,637050,733393,927611,603164,164631,1016893,836509,364503,583288,1025998,509737,256475,326733,314410,675312,584418,499854,188463,210667,665245,599764,200547,916573,347525,109338,764997,862835,673877,526282,134128,371319,1024765,854593,405022,704935,909506,474933,292866,93165,763939,328878,543861,991445,102032,711646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]