SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501805 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501805 [ RunTime:0.002417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294711,732256,923892,942305,403317,777980,150927,491697,159792,899313,616949,174012,642662,78563,936505,997932,45184,545487,415257,407838,739643,191442,468378,358548,843435,400317,929370,372884,808120,214505,149678,778735,679330,238138,98875,819635,602400,423238,724475,784552,387415,597320,75606,73764,389364,363397,928622,153799,258974,246902,289250,250614,47520,160203,738842,887819,310236,330588,121404,43168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]