SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101403 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101403 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040745,843942,626638,657277,464763,539728,784026,202815,794977,692416,773660,13973,874496,331762,347899,702418,362057,776373,1015389,853725,168288,483579,958397,611402,191569,787038,660393,302250,474910,309028,658129,153130,72622,1006978,345330,753416,173626,650148,883396,382922,862962,339425,576187,730206,310097,711046,85180,107745,790733,548229,755484,705082,798933,434336,203548,1025094,3834,374725,910738,63495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]