SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204800 LIMIT 1 [ RunTime:0.000761s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204800 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95719,350869,1016160,271373,548968,986064,15306,47684,181435,1029478,263047,412934,468831,867688,538534,786059,683566,329680,318912,281290,280875,305522,464131,48378,796937,651294,55858,126496,644593,446315,540953,585271,661275,6039,51498,911636,253373,589974,816090,12682,322490,471790,157906,387682,767445,111751,403099,42519,194661,914973,358007,134819,693142,149690,497261,265877,296192,962391,216556,853398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]