SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32611 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32611 [ RunTime:0.003061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767611,247991,579024,971542,526017,541969,416330,955883,437154,926618,180250,1027861,465698,230784,645621,534196,1000489,438730,47394,121354,1022590,244452,35187,190172,586548,1014896,564416,968714,416526,142516,276253,892977,314514,593064,362827,382752,189833,588949,787717,24795,268200,388985,442864,154572,215663,947882,138878,673148,238935,977441,216621,909368,1000006,567554,929459,664162,838099,219903,450379,383377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001796s ]