SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419435 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419435 [ RunTime:0.002780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469345,798217,524711,734556,523821,1040118,584729,883197,939570,77064,566864,561997,647852,985711,506619,906590,723772,1027158,231519,244611,387462,988286,715157,281073,248809,505889,643921,361032,462476,66980,385841,182959,453742,846752,203646,225252,810547,816496,541046,481618,823308,705083,73113,46420,414333,821324,590576,179954,665,595235,734942,951343,869457,123782,83930,460430,763763,222427,887855,707338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]