SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433713 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433713 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754400,738716,320366,34151,735574,410585,221488,623856,560347,1022870,1043617,887601,1037041,311029,1026592,48045,1042607,284785,453346,31007,956469,390494,867110,283512,22738,392858,364179,908224,146570,963076,35792,35232,969616,1045707,325484,988644,926053,516354,739541,759683,521281,944014,176890,125850,641008,427334,734898,848851,137746,726988,678500,573682,436604,243085,651539,653177,42768,541553,250292,414099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]